package com.cortex.carambola.database;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class DbHelper extends SQLiteOpenHelper{

	public final static String DB_NAME = "dbSummary";
	public final static String TABLE_NAME = " summary ";
	public final static String COL_ID = " id ";
	public final static String COL_NAME = " Name ";
	public final static String COL_SUMMARY = " summary ";
	public final static String COL_SENTENCES = " sentences ";
	public final static String COL_KEYWORDS = " keywords ";
	public final static String COL_IS_QUOTES = " isQuotes ";
	public final static String COL_CHARACTERS = " characters ";
	public final static String COL_URL = " url ";
	
	private final static int version = 1;
	private final static String CREATE_TABLE = "create table"    + TABLE_NAME + 
			" (" + COL_ID + "integer PRIMARY KEY AUTOINCREMENT," + COL_NAME + "text,"  + COL_SUMMARY + "text," + 
			COL_SENTENCES + "text," + COL_KEYWORDS + "text," + COL_IS_QUOTES + "integer," + 
			COL_CHARACTERS + "text," + COL_URL + "text)";
	
	public DbHelper(Context context) {
		super(context, DB_NAME, null, version);
	}

	public void onCreate(SQLiteDatabase db) {
		db.execSQL(CREATE_TABLE);
	}

	public void onUpgrade(SQLiteDatabase arg0, int arg1, int arg2) {
		
	}

}
